# ADO Open Method

Complete Record Object Reference

The Open method opens an existing Record object or creates a new file or directory.

### Syntax

Open(source,actconn,mode,createopt,opt,username,psword)

Parameter | Description
--- | ---

source

Optional. The source parameter may be one of the following:

- An absolute url
- A relative url
- An open Recordset
- Another Record object
- A Command object
- An SQL SELECT statement
- A table name

actconn | Optional. A connection string or a Connection object
mode | Optional. A ConnectModeEnum value, that indicates the access mode of the Record object. Default is adModeUnknown
createopt | Optional. A RecordCreateOptionsEnum value, that indicates whether an existing file/directory should be opened, or a new file/directory should be created. Default is adFailIfNotExists. This parameter will be ignored if the source parameter is not a URL
opt | Optional. One or more RecordOpenOptionsEnum values, that specifies the options for opening the Record. Default is adOpenRecordUnspecified
username | Optional. A user ID that authorizes access to source
psword | Optional. A password that verifies the username

### Example

Example 1: source as the URL of a folder:
set rec = Server.CreateObject("ADODB.record")
rec.Open("http://www.w3schools.com/asp/")
Example 2: source as a relative URL in a Connection object:
set conn=Server.CreateObject("ADODB.Connection")
set rec = Server.CreateObject("ADODB.record")
conn.Open "URL=http://www.w3schools.com/asp/"
rec.Open("test.doc", conn)
Example 3: source as a row in a Recordset object:
set rs = Server.CreateObject("ADODB.recordset")
set rec = Server.CreateObject("ADODB.record")
rs.Open "test.doc", "URL=http://www.w3schools.com/asp/",,,adCmdTableDirect
rs.MoveLast()
rec.Open(rs)

### ConnectModeEnum Values

Constant | Value | Description
--- | --- | ---
adModeUnknown | 0 | Default. Permissions have not been set or cannot be determined
adModeRead | 1 | Read-only
adModeWrite | 2 | Write-only
adModeReadWrite | 3 | Read/write
adModeShareDenyRead | 4 | Prevents others from opening a connection with read permissions
adModeShareDenyWrite | 8 | Prevents others from opening a connection with write permissions
adModeShareExclusive | 12 | Prevents others from opening a connection
adModeShareDenyNone | 16 | Allows others to open a connection with any permissions
adModeRecursive | 0x400000 | Used with adModeShareDenyNone, adModeShareDenyWrite, or adModeShareDenyRead to set permissions on all sub-records of the current Record

### RecordCreateOptionsEnum Values

Constant | Value | Description
--- | --- | ---
adFailIfNotExists | -1 | Default. Fails if the source parameter points to a node that not exists
adCreateNonCollection | 0 | Creates a new Record of type adSimpleRecord
adCreateCollection | 0x2000 | Creates a new Record specified by the source parameter. If it points to an existing node, an error will occur. To prevent the error combine this value with adOpenIfExists or adCreateOverwrite
adOpenIfExists | 0x2000000 | If the source points to an existing node or Record object, then the provider must open the existing Record instead of creating a new one. This value cannot be used with adCreateOverwrite
adCreateOverwrite | 0x4000000 | If the source points to an existing node or Record, then the existing Record will be overwritten and a new one is created in its place. This value cannot be used with adOpenIfExists
adCreateStructDoc | 0x80000000 | Creates a new Record of type adStructDoc

### RecordOpenOptionsEnum Values

Constant | Value | Description
--- | --- | ---
adOpenRecordUnspecified | -1 | Default. No options are specified
adOpenAsync | 0x1000 | Opens the Record object in asynchronous mode
adDelayFetchStream | 0x4000 | The default stream associated with the Record need not be retrieved initially
adDelayFetchFields | 0x8000 | The fields associated with the Record need not be retrieved initially, but can be retrieved at the first attempt to access the field
adOpenExecuteCommand | 0x10000 | The source contains command text that should be executed
adOpenOutput | 0x800000 | If the source points to a node that contains an executable script, then the opened Record will contain the results of the executed script. This value is only valid with non-collection records

Complete Record Object Reference

### WEB HOSTING

UK Reseller Hosting

### WEB BUILDING

FREE Website BUILDER Free HTML5 Templates

### W3SCHOOLS EXAMS

HTML, CSS, JavaScript, PHP, jQuery, XML, and ASP Certifications

### SHARE THIS PAGE

### Color Picker

### HTML/CSS

HTML Tutorial HTML5 Tutorial CSS Tutorial CSS3 Tutorial Bootstrap Tutorial

### JavaScript

JavaScript Tutorial jQuery Tutorial jQuery Mobile Tutorial AngularJS Tutorial AJAX Tutorial JSON Tutorial

### Graphics

Canvas Tutorial SVG Tutorial Google Maps Tutorial

### Server Side

SQL Tutorial PHP Tutorial ASP Tutorial ASP.NET Tutorial VBScript Tutorial AppML Tutorial

### Web

Web Building Web Statistics Web Certification

### XML

XML Tutorial DTD Tutorial Schema Tutorial XML DOM Tutorial XPath Tutorial XSLT Tutorial XQuery Tutorial XSL-FO Tutorial RSS Tutorial WSDL Tutorial

### HTML/CSS

HTML Tag Reference HTML Event Reference HTML Color Reference CSS 1,2,3 Reference Bootstrap Reference

### JavaScript

JavaScript Reference HTML DOM Reference jQuery Reference jQuery Mobile Reference Google Maps Reference

### Server Side

PHP Reference SQL Reference ASP Reference VBScript Reference Razor Reference ASP.NET Reference

### XML

XML DOM Reference XSLT Reference XSL-FO Reference XPath Reference XQuery Reference Schema Reference RSS Reference SVG Reference

### HTML Charsets

HTML Character Sets HTML ASCII HTML ANSI HTML Windows-1252 HTML ISO-8859-1 HTML Symbols HTML UTF-8

### HTML/CSS

HTML Examples CSS Examples

### Browser Scripting

JavaScript Examples HTML DOM Examples jQuery Examples jQuery Mobile Examples AngularJS Examples AJAX Examples

### Server Scripting

PHP Examples ASP Examples VBScript Examples Razor Examples .NET Examples

### XML Languages

XML Examples DTD Examples XML DOM Examples XSL Examples XSLT Examples XPath Examples XQuery Examples Schema Examples RSS Examples SVG Examples